Sales Order Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
tblSoCustLevel -- SO Customer Level table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
CustLevel | nvarchar | 10 | |||
Descr | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSoHistReturnedItem -- SO Returned Item History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
CostExt | pDecimal | 13 | |||
Counter | int | 4 | |||
CustId | pCustID | 10 | |||
EntryDate | datetime | 8 | |||
EntryNum | int | 4 | |||
ExtLocA | int | 4 | |||
ExtLocAId | varchar | 10 | |||
ExtLocB | int | 4 | |||
ExtLocBId | varchar | 10 | |||
FiscalYear | smallint | 2 | |||
GLAcctCOGS | pGlAcct | 40 | |||
GLAcctInv | pGlAcct | 40 | |||
GlPeriod | smallint | 2 | |||
ItemDescr | varchar | 35 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
Notes | nvarchar | max | |||
PostDate | datetime | 8 | |||
PostRun | pPostRun | 14 | |||
PriceExt | pDecimal | 13 | |||
QtyReturn | pDecimal | 13 | |||
ResCode | varchar | 10 | |||
ResCodeDescr | varchar | 35 | |||
RMANumber | pInvoiceNum | 15 | |||
SerNum | pSerNum | 35 | |||
Status | tinyint | 1 | Status | 0 = Approved, 1 = New, 9 = Posted | |
TransDate | datetime | 8 | |||
TransId | pTransID | 8 | |||
UnitCost | pDecimal | 13 | |||
UnitPrice | pDecimal | 13 | |||
Units | pUom | 5 | |||
CF | xml | -1 |
tblSoItemLocPrice -- SO Item Location Price table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
CustLevel | nvarchar | 10 | |||
Descr | nvarchar | 35 | |||
PriceAdjBase | tinyint | 1 | 0 | Price Adjustment Basis | 0 = No Base, 1 = Standard Cost, 2 = Base Cost, 3 = Average Price, 4 = Base Price, 5 = List Price, 6 = Minimum Price, 7 = Calculated Price |
PriceAdjType | tinyint | 1 | 0 | Price Adjustment Type | 0 = Amount, 1 = Percent |
PriceAdjAmt | pDecimal | 13 | 0 | ||
PriceAdjPromoYn | bit | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblSoPriceContractCustomer -- SO Contract Pricing Customer table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HeaderId | bigint | ||||
CustId | pCustID | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblSoPriceContractDetail -- SO Contract Pricing Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
SeqNum | bigint | ||||
HeaderId | bigint | ||||
BreakAmount | pDecimal | 13 | 0 | ||
BreakUOM | pUom | ||||
AdjustmentBase | tinyint | ||||
AdjustmentType | tinyint | ||||
AdjustmentAmount | pDecimal | 13 | 0 | ||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblSoPriceContractHeader -- SO Contract Pricing Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | ||||
ContractPriceId | nvarchar | 10 | |||
Description | nvarchar | 35 | |||
PriceBreakType | smallint | ||||
StartDate | datetime | 8 | |||
EndDate | datetime | 8 | |||
CustomerFilter | nvarchar | max | |||
ItemFilter | nvarchar | max | |||
PerItemPricingYN | bit | 1 | 0 | ||
CustomerFilterSql | nvarchar | max | |||
ItemFilterSql | nvarchar | max | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblSoPriceContractItem -- SO Contract Pricing Item table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HeaderId | bigint | ||||
ItemId | pItemID | 24 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSoPricePromo -- SO Price Promotion table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PromoId | nvarchar | 10 | |||
Descr | nvarchar | 35 | |||
PriceIdFrom | nvarchar | 10 | |||
PriceIdThru | nvarchar | 10 | |||
CustLevelFrom | nvarchar | 10 | |||
CustLevelThru | nvarchar | 10 | |||
ProductLineFrom | nvarchar | 12 | |||
ProductLineThru | nvarchar | 12 | |||
ItemIdFrom | pItemID | 24 | |||
ItemIdThru | pItemID | 24 | |||
UomFrom | pUom | 5 | |||
UomThru | pUom | 5 | |||
LocIdFrom | pLocID | 10 | |||
LocIdThru | pLocID | 10 | |||
UsrFld1From | nvarchar | 12 | |||
UsrFld1Thru | nvarchar | 12 | |||
UsrFld2From | nvarchar | 12 | |||
UsrFld2Thru | nvarchar | 12 | |||
PriceAdjBase | tinyint | 1 | 0 | Price Adjustment Basis | 0 = No Base, 1 = Standard Cost, 2 = Base Cost, 3 = Average Price, 4 = Base Price, 5 = List Price, 6 = Minimum Price, 7 = Calculated Price |
PriceAdjType | tinyint | 1 | 0 | Price Adjustment Type | 0 = Amount, 1 = Percent |
PriceAdjAmt | pDecimal | 13 | 0 | ||
DateStart | datetime | 8 | |||
DateEnd | datetime | 8 | |||
WebOnlyYn | bit | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSoPriceStructDetail -- SO Price Structure Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PriceId | nvarchar | 10 | |||
CustLevel | nvarchar | 10 | |||
Descr | nvarchar | 35 | |||
PriceAdjBase | tinyint | 1 | 0 | Price Adjustment Basis | 0 = No Base, 1 = Standard Cost, 2 = Base Cost, 3 = Average Price, 4 = Base Price, 5 = List Price, 6 = Minimum Price, 7 = Calculated Price |
PriceAdjType | tinyint | 1 | 0 | Price Adjustment Type | 0 = Amount, 1 = Percent |
PriceAdjAmt | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSoPriceStructHeader -- SO Price Structure Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PriceId | nvarchar | 10 | |||
Descr | nvarchar | 35 | |||
DfltAdjBase | tinyint | 1 | 0 | Default Price Adjustment Basis | 0 = No Base, 1 = Standard Cost, 2 = Base Cost, 3 = Average Price, 4 = Base Price, 5 = List Price, 6 = Minimum Price, 7 = Calculated Price |
DfltAdjType | tinyint | 1 | 0 | Default Price Adjustment Type | 0 = Amount, 1 = Percent |
DfltAdjAmt | pDecimal | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSoReasonCode -- SO Reason Code table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ResCode | nvarchar | 10 | |||
Descr | nvarchar | 35 | |||
ActiveYN | bit | 1 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSoReturnedItem -- SO Returned Item table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
Status | tinyint | 1 | -1 | Returned Item Status | 0 = Approved, 1 = New, 9 = Posted |
ResCode | nvarchar | 10 | |||
RMANumber | pInvoiceNum | 15 | |||
CustID | pCustID | 10 | |||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
ExtLocA | int | 4 | |||
ExtLocAID | nvarchar | 10 | |||
ExtLocB | int | 4 | |||
ExtLocBID | nvarchar | 10 | |||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
Units | pUom | 5 | |||
QtyReturn | pDecimal | 13 | 0 | ||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
UnitCost | pDecimal | 13 | 0 | ||
CostExt | pDecimal | 13 | 0 | ||
UnitPrice | pDecimal | 13 | 0 | ||
PriceExt | pDecimal | 13 | 0 | ||
QtySeqNum | int | 4 | 0 | ||
QtySeqNumExt | int | 4 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
HistSeqNumSer | int | 4 | 0 | ||
GLAcctCOGS | pGlAcct | 40 | |||
GLAcctInv | pGlAcct | 40 | |||
Notes | text | 16 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSoSaleBlanket -- SO Sale Blanket table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BlanketRef | int | 4 | |||
BatchId | pBatchID | 6 | |||
BlanketId | pTransID | 8 | |||
ExpireDate | datetime | 8 | |||
CloseDate | datetime | 8 | |||
ContractDate | datetime | 8 | getdate() | ||
ContractAmount | pDecimal | 13 | 0 | ||
Freight | pDecimal | 13 | 0 | ||
Misc | pDecimal | 13 | 0 | ||
Subtotal | pDecimal | 13 | |||
LocId | pLocID | 10 | |||
CustLevel | nvarchar | 10 | |||
DistCode | pDistCode | 6 | |||
SoldToId | pCustID | 10 | |||
CustId | pCustID | 10 | |||
TermsCode | pTermsCode | 6 | |||
TaxableYN | bit | 1 | -1 | ||
TaxOnFreight | bit | 1 | -1 | ||
TaxClassFreight | tinyint | 1 | 0 | ||
TaxClassMisc | tinyint | 1 | 0 | ||
PODate | datetime | 8 | getdate() | ||
CustPONum | nvarchar | 25 | |||
ShipToId | pCustID | 10 | |||
ShipToName | nvarchar | 30 | |||
ShipToAddr1 | nvarchar | 30 | |||
ShipToAddr2 | nvarchar | 60 | |||
ShipToCity | nvarchar | 30 | |||
ShipToRegion | nvarchar | 10 | |||
ShipToCountry | pCountry | 6 | |||
ShipToPostalCode | nvarchar | 10 | |||
ShipVia | nvarchar | 20 | |||
ShipToPhone | nvarchar | 24 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
CurrencyId | pCurrency | 6 | |||
Notes | nvarchar | max | |||
ShipToId | pCustID | 10 | |||
TaxGrpId | pTaxLoc | 10 | |||
BlanketStatus | smallint | 1 | 0 | Blanket Status | 0 = Open, 1 = On Hold, 2 = Closed |
BlanketType | smallint | 1 | 0 | Blanket Type | 0 = Amount, 1 = On Demand, 2 = Scheduled |
ts | timestamp | 8 | |||
CF | xml | -1 | |||
*TaxGrpId2 | pTaxLoc | ||||
*FreightTermID | bigint | ||||
*FreightAccountNumber | nvarchar | 255 | |||
*DeliverySurcharge | bit | 1 | 0 | ||
*ResidentialYN | bit | 1 | 0 | ||
*GlobalLocationNumber | nvarchar | 13 |
tblSoSaleBlanketActivity -- SO Sale Blanket Activity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BlanketDtlRef | int | 4 | |||
BlanketRef | int | 4 | |||
EntryDate | datetime | 8 | |||
Id | int | 4 | |||
PostRun | pPostRun | 14 | |||
PriceExt | pDecimal | 13 | |||
Qty | pDecimal | 13 | |||
RecType | smallint | 2 | Record Type | 1 = Line Item, 2 = Freight, 3 = Misc | |
TransDate | datetime | 8 | |||
TransId | pTransID | 8 | |||
TransType | smallint | 2 | Transaction Type | 1 = Release, -1 = Credit | |
ts | timestamp | 8 |
tblSoSaleBlanketDetail -- SO Sale Blanket Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BlanketDtlRef | int | 4 | |||
BlanketRef | int | 4 | |||
EntryDate | datetime | 8 | |||
Id | int | 4 | |||
LineSeq | int | 4 | |||
LocId | pLocID | 10 | |||
ItemId | pItemID | 24 | |||
CatId | nvarchar | 2 | |||
TaxClass | tinyint | 1 | 0 | ||
AcctCode | pGLAcctCode | 2 | |||
GLAcctSales | pGlAcct | 40 | |||
GLAcctCOGS | pGlAcct | 40 | |||
GLAcctInv | pGlAcct | 40 | |||
LotNum | pLotNum | 16 | |||
PostRun | pPostRun | 14 | |||
PriceExt | pDecimal | 13 | 0 | ||
Qty | pDecimal | 13 | |||
QtyOrdered | pDecimal | 13 | 0 | ||
QtyReleased | pDecimal | 13 | 0 | ||
Units | pUom | 5 | |||
UnitPrice | pDecimal | 13 | 0 | ||
UnitCost | pDecimal | 13 | 0 | ||
CostExt | pDecimal | 13 | 0 | ||
RecType | smallint | 2 | Record Type | 1 = Line Item, 2 = Freight, 3 = Misc | |
GrpId | int | 4 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
UnitCommBasis | pDecimal | 13 | 0 | ||
TransDate | datetime | 8 | |||
TransId | pTransID | 8 | |||
TransType | smallint | 2 | Transaction Type | 1 = Release, -1 = Credit | |
ts | timestamp | 8 | |||
AddnlDescr | nvarchar | max | |||
Descr | pDescription | 255 | |||
PriceId | pTaxLoc | 10 | |||
PromoId | pTaxLoc | 10 | |||
CustomerPartNumber | pDescription | ||||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblSoSaleBlanketDetailSch -- SO Sale Blanket Detail Schedule table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BlanketDtlRef | int | 4 | |||
BlanketDtlSchRef | int | 4 | |||
ReleaseDate | datetime | 8 | |||
QtyOrdered | pDecimal | 13 | 0 | ||
ts | timestamp | 8 | |||
CF | xml | -1 | |||
Status | tinyint | 1 | 0 | Blanket Order Status | 0 = New, 1 = Released, 2 = On Hold |
tblSoTransDetail -- SO Transaction Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransID | pTransID | 8 | |||
EntryNum | int | 4 | |||
ItemJob | tinyint | 1 | 0 | Item / Job Flag | 0 = Item, 1 = Job |
LocId | pLocID | 10 | |||
ItemId | pItemID | 24 | |||
JobId | nvarchar | 10 | |||
PhaseId | nvarchar | 10 | |||
JobCompleteYN | bit | 1 | 0 | ||
ItemType | tinyint | 1 | 0 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item |
Descr | nvarchar | 35 | |||
AddnlDescr | text | 16 | |||
CatId | nvarchar | 2 | |||
TaxClass | tinyint | 1 | 0 | ||
AcctCode | pGLAcctCode | 2 | |||
GLAcctSales | pGlAcct | 40 | |||
GLAcctCOGS | pGlAcct | 40 | |||
GLAcctInv | pGlAcct | 40 | |||
QtyOrdSell | pDecimal | 13 | 0 | ||
UnitsSell | pUom | 5 | |||
UnitsBase | pUom | 5 | |||
QtyShipSell | pDecimal | 13 | 0 | ||
QtyShipBase | pDecimal | 13 | 0 | ||
QtyBackordSell | pDecimal | 13 | 0 | ||
PriceID | nvarchar | 10 | |||
UnitPriceSell | pDecimal | 13 | 0 | ||
UnitPriceSellFgn | pDecimal | 13 | 0 | ||
UnitCostSell | pDecimal | 13 | 0 | ||
UnitCostSellFgn | pDecimal | 13 | 0 | ||
PriceExt | pDecimal | 13 | 0 | ||
PriceExtFgn | pDecimal | 13 | 0 | ||
CostExtFgn | pDecimal | 13 | 0 | ||
CostExt | pDecimal | 13 | 0 | ||
PromoID | nvarchar | 10 | |||
ReqShipDate | datetime | 8 | |||
ActShipDate | datetime | 8 | |||
EffectiveRate | pDecimal | 13 | 0 | ||
OrigOrderQty | pDecimal | 13 | 0 | ||
BinNum | nvarchar | 10 | |||
ConversionFactor | pDecimal | 13 | -1 | ||
LottedYN | bit | 1 | 0 | ||
InItemYN | bit | 1 | -1 | ||
HistSeqNum | int | 4 | 0 | ||
GrpId | int | 4 | |||
Kit | bit | 1 | 0 | ||
KitQty | pDecimal | 13 | -1 | ||
KitQtyBackOrdered | pDecimal | 13 | 0 | ||
OriCompQty | pDecimal | 13 | 0 | ||
QtySeqNum_Cmtd | int | 4 | 0 | ||
QtySeqNum | int | 4 | 0 | ||
LineSeq | int | 4 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
UnitCommBasis | pDecimal | 13 | 0 | ||
UnitCommBasisFgn | pDecimal | 13 | 0 | ||
PriceAdjType | tinyint | 1 | 0 | Price Adjustment Type | 0 = Amount, 1 = Percent |
PriceAdjPct | pDecimal | 13 | 0 | ||
PriceAdjAmt | pDecimal | 13 | 0 | ||
PriceAdjAmtFgn | pDecimal | 13 | 0 | ||
Status | tinyint | 1 | 0 | Line Item Status | 0 = Open, 1 = Completed |
TotQtyOrdSell | pDecimal | 13 | 0 | ||
TotQtyShipSell | pDecimal | 13 | 0 | ||
ResCode | nvarchar | 10 | |||
UnitPriceSellBasis | pDecimal | 13 | 0 | ||
UnitPriceSellBasisFgn | pDecimal | 13 | 0 | ||
BlanketDtlRef | int | 4 | |||
BOLNum | nvarchar | 17 | |||
LinkSeqNum | int | 4 | |||
CustomerPartNumber | pDescription | ||||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblSoTransDetailExt -- SO Extended Transaction Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Cmnt | nvarchar | 35 | |||
CostUnit | pDecimal | 13 | |||
CostUnitFgn | pDecimal | 13 | |||
EntryNum | int | 4 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
HistSeqNum | int | 4 | |||
LotNum | pLotNum | 16 | |||
QtyFilled | pDecimal | 13 | |||
QtyOrder | pDecimal | 13 | |||
QtySeqNum | int | 4 | |||
QtySeqNum_Cmtd | int | 4 | |||
QtySeqNum_Ext | int | 4 | |||
SeqNum | int | 4 | |||
TransId | pTransID | 8 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblSoTransHeader -- SO Transaction Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
TransType | smallint | 2 | -9 | Transaction Type | 1 = Invoice, 2 = Price Quote, 3 = Backordered, 4 = Verified, 5 = Picked, 8 = Void Sales, 9 = New, -1 = Credit Memo, -2 = RMA, -8 = Void Returns (1 = Sales, -1 = Returns) |
VoidYn | bit | 1 | 0 | ||
BatchId | pBatchID | 6 | '######' | ||
LocId | pLocID | 10 | |||
CustId | pCustID | 10 | |||
CustLevel | nvarchar | 10 | |||
ShipToID | pCustID | 10 | |||
ShipToName | nvarchar | 30 | |||
ShipToAddr1 | nvarchar | 30 | |||
ShipToAddr2 | nvarchar | 60 | |||
ShipToCity | nvarchar | 30 | |||
ShipToRegion | nvarchar | 10 | |||
ShipToCountry | pCountry | 6 | |||
ShipToPostalCode | nvarchar | 10 | |||
ShipVia | nvarchar | 20 | |||
TermsCode | pTermsCode | 6 | |||
DistCode | pDistCode | 6 | |||
InvcNum | pInvoiceNum | 15 | |||
OrgInvcNum | pInvoiceNum | 15 | |||
-*OrgInvcExchRate | pDecimal | 13 | -1 | ||
InvcDate | datetime | 8 | getdate() | ||
TransDate | datetime | 8 | getdate() | ||
PODate | datetime | 8 | getdate() | ||
CustPONum | nvarchar | 25 | |||
ShipNum | nvarchar | 18 | |||
ReqShipDate | datetime | 8 | getdate() | ||
ActShipDate | datetime | 8 | |||
Rep1Id | pSalesRep | 3 | |||
Rep1Pct | pDecimal | 13 | 0 | ||
Rep2Id | pSalesRep | 3 | |||
Rep2Pct | pDecimal | 13 | 0 | ||
TaxableYN | bit | 1 | -1 | ||
TaxOnFreight | bit | 1 | -1 | ||
TaxClassFreight | tinyint | 1 | 0 | ||
TaxClassMisc | tinyint | 1 | 0 | ||
TaxGrpID | pTaxLoc | 10 | |||
TaxableSales | pDecimal | 13 | 0 | ||
NonTaxableSales | pDecimal | 13 | 0 | ||
SalesTax | pDecimal | 13 | 0 | ||
Freight | pDecimal | 13 | 0 | ||
Misc | pDecimal | 13 | 0 | ||
TotCost | pDecimal | 13 | 0 | ||
CurrencyID | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
-*CalcGainLoss | pDecimal | 13 | 0 | ||
PickNum | pInvoiceNum | 15 | |||
PrintAcknowStatus | tinyint | 1 | 0 | Order Acknowledgement Print Status | 0 = Unprinted, 1 = Online, 2 = Batch |
PrintPackStatus | tinyint | 1 | 0 | Packing List Print Status | 0 = Unprinted, 1 = Online, 2 = Batch |
PackNum | pInvoiceNum | 15 | |||
PostDate | datetime | 8 | |||
GLPeriod | smallint | 2 | 0 | ||
FiscalYear | smallint | 2 | 0 | ||
-*SumHistPeriod | smallint | 2 | -1 | ||
PrintInvcStatus | tinyint | 1 | 0 | Invoice Print Status | 0 = Unprinted, 1 = Online, 2 = Batch |
PrintPickStatus | tinyint | 1 | 0 | Picking Slip Print Status | 0 = Unprinted, 1 = Online, 2 = Batch, 4 = WM Generated |
NetDueDate | datetime | 8 | |||
DiscDueDate | datetime | 8 | |||
DiscAmt | pDecimal | 13 | 0 | ||
DiscAmtFgn | pDecimal | 13 | 0 | ||
TaxAmtAdj | pDecimal | 13 | 0 | ||
TaxAdj | tinyint | 1 | -1 | ||
TaxLocAdj | pTaxLoc | 10 | |||
TaxClassAdj | tinyint | 1 | 0 | ||
TaxableSalesFgn | pDecimal | 13 | 0 | ||
NonTaxableSalesFgn | pDecimal | 13 | 0 | ||
SalesTaxFgn | pDecimal | 13 | 0 | ||
FreightFgn | pDecimal | 13 | 0 | ||
MiscFgn | pDecimal | 13 | 0 | ||
TotCostFgn | pDecimal | 13 | 0 | ||
TaxAmtAdjFgn | pDecimal | 13 | 0 | ||
Layaway | bit | 1 | 0 | ||
ShipToPhone | nvarchar | 24 | |||
Notes | text | 16 | |||
Rep1CommRate | pDecimal | 13 | 0 | ||
Rep2CommRate | pDecimal | 13 | 0 | ||
SoldToId | pCustID | 10 | |||
BlanketRef | int | 4 | |||
SourceId | uniqueidentifier | 16 | newid() | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*OrgInvoiceID | int | 4 | |||
*TaxGrpId2 | pTaxLoc | ||||
*FreightTermID | bigint | ||||
*FreightAccountNumber | nvarchar | 255 | |||
*DeliverySurcharge | bit | 1 | 0 | ||
*ResidentialYN | bit | 1 | 0 | ||
*GlobalLocationNumber | nvarchar | 13 | |||
*TotalCharges | pDecimal | 13 | 0 | ||
*ActualWeight | pDecimal | 13 | 0 | ||
*ShipToFax | nvarchar | 15 | |||
*ShipToEmail | pEmail | ||||
*NumberOfPackage | Int | 4 | |||
*ReqDeliveryDate | datetime | 8 |
tblSoTransPmt -- SO Transaction Payment table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PmtNum | int | 4 | |||
PmtDate | datetime | 8 | getdate() | ||
TransId | pTransID | 8 | |||
DepositId | pBatchID | 6 | |||
LinkId | int | 4 | |||
PmtMethodId | nvarchar | 10 | |||
CcNum | nvarchar | 510 | |||
CcHolder | nvarchar | 30 | |||
CcExpire | datetime | 8 | |||
CcAuth | nvarchar | 10 | |||
CheckNum | pCheckNum | 10 | |||
Note | nvarchar | 25 | |||
PmtAmt | pDecimal | 13 | 0 | ||
PmtAmtFgn | pDecimal | 13 | 0 | ||
CurrencyId | pCurrency | 6 | |||
ExchRate | pDecimal | 13 | -1 | ||
CalcGainLoss | pDecimal | 13 | 0 | ||
PostedYn | bit | 1 | 0 | ||
CcSecCode | nvarchar | 6 | |||
BankName | nvarchar | 30 | |||
BankRoutingCode | nvarchar | 9 | |||
BankAcctNum | nvarchar | 510 | |||
GlPeriod | smallint | 2 | -1 | ||
FiscalYear | smallint | 2 | 0 | ||
GlAcctReceivables | pGlAcct | 40 | |||
GlAcctGainLoss | pGlAcct | 40 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtPmtActivityID | bigint | 8 |
tblSoTransSer -- SO Transaction Serial Number table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
PriceUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
*CostUnitACV | pDecimal | 13 |
tblSoTransTax -- SO Transaction Tax table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
TaxLocID | pTaxLoc | 10 | |||
TaxClass | tinyint | 1 | 0 | ||
Level | tinyint | 1 | -1 | ||
TaxAmt | pDecimal | 13 | 0 | ||
TaxAmtFgn | pDecimal | 13 | 0 | ||
Taxable | pDecimal | 13 | 0 | ||
TaxableFgn | pDecimal | 13 | 0 | ||
NonTaxable | pDecimal | 13 | 0 | ||
NonTaxableFgn | pDecimal | 13 | 0 | ||
LiabilityAcct | pGlAcct | 40 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
TaxGroupType | tinyint | 1 | 0 | 0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2 | |
ExpenseAccount | pGlAcct |